Приложение 2. Коды основных файлов проекта "MyMail"

Приложение 2

Коды основных файлов проекта "MyMail"

Данное приложение является дополнением главы 16, представляющей описание проекта "MyMail", и предназначено для демонстрации кода основных файлов данного проекта, в частности: Application.cfm, main.js, selectchecks.js, main.css, ie.css, login.cfm, signup.cfm, sendpassword.cfm, edituser.cfm, mailbox.cfm, receiving_mail.cfm, movedel_mail.cfm, emptydel.cfm, view_mail.cfm,
properties_mail.cfm, newmail.cfm, addresses.cfm, addeditdel_addr.cfm,
deletesel_addr.cfm, logout.cfm.

Листинг П2.1. Код конфигурационного файла Application.cfm

<CFAPPLICATION
NAME="MyMail"

APPLICATIONTIMEOUT="#createTimeSpan(0,1,0,0)1"

SESSIONTIMEOUT="#createTimeSpan(0,0,20,0)1"
SESSIONMANAGEMENT="Yes"
CLIENTMANAGEMENT="Yes"
SETCLIENTCOOKIES="Yes"
CLIENTSTORAGE="registry">

<CFPARAM NAME="application.pop" r>F,FAOLT="192 .168 . 3 . 60">

<CFPARAM NAME="application.msgErrorLogin"

DEFAULT="You have entered not the correct data!">
<CFPARAM NAME="application.msgErrorl"

DEFAULT="Login should consist from more than 3 symbols">
<CFPARAM NAME="application.msgError2"

DEFAULT="Password should consist from more than 4 symbols">
<CFPARAM NAME="application.msgError3"

DEFAULT="Password should not consist only of numbers">
<CFPARAM NAME="application.msgError4"

DEFAULT="Password and Confirm, should be identical">
<CFPARAM NAME="application.msgError5"

DEFAULT="First Name, should not be empty">
<CFPARAM NAME="application.msgError6"

DEFAULT="Last Name, should not be empty">

Листинг П2.2. Код файла main.js

var ns = (document.layers)? true:false
var ie = (document.all)? true:false

if (ie) {document.write('<clink rel="stylesheet"

type="text/css" href="ie.ess" title="master">');}

function layerWrite(id,nestref, text) {

if (ns) {

var lyr = (nestref)?

eval('document.'+nestref+'.document.'+id+'.document') :
document.layers[id].document

lyr.open()

lyr.write(text)

lyr.close()
}
else if (ie) document.all[id].innerHTML = text

}

Листинг П2.3. Код файла selectchecks.js

function SelUnsellnv (block) {

if (ns) var idxlen =
document . layers [block] . document . form2 . elements . length;

else var idxlen = document . form2 .elements . length;

return idxlen;
}
function SelectAll (block) {

idxlen = SelUnsellnv (block) ;

for (i=0;i<idxlen;i++) {

if(ns) document, layers [block] .document. form2. elements [i] .checked=true;

else document . form2 .elements (i) .checked = true;

}

function UnselectAll (block) {
idxlen = SelUnsellnv (block) ;
for (i=0;i<idxlen;i++) {

if(ns) document, layers [block] .document. form2. elements [i] . checked=false;

else document. form2. elements (i) .checked = false;
}
}

function InvertChecks (block) {
idxlen = SelUnsellnv (block) ;
for (i=0;i<idxlen;i++) {
if(ns) {

if
(document . layers [block] .document . form2 .elements [i] . checked==true) {

document . layers [block] .document. form2 . elements [i] . checked=false;

} else {
document . layers [block] .document . form2 . elements [i] . checked=true;

} else {

i Г* (document.form2.elements (i) ..checked==true)

document.form2.elements(i).checked = false;
} else {

document.form2.elements(i).checked = true;
}
}
}
}

Листинг П2.4. Код файла main. ess

A {color:#4B4558;}

A:hover {color: I3366CC; text-decoration : underline;}

.txtmenu {

color : #4B4558;

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;

font-size : 12px;

}

.txtmenustat {

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;

I
font-size : 12px;

padding : 3px;

color : I4B4558;

}

.txtprompt {"

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;

font-size : llpx;

color : I4B4558;

}

.title {

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;

font-weight : bold;
font-size : 17px;
color : I4B4558;
}

.txtForml {

padding : Opx;

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;

font-size : llpx;

color : Black;

}

INPUT {

padding : 0px;

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;

font-size : llpx;

}

TEXTAREA {

padding : 0px;

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;

font-size : llpx;

}

.txtError {

padding : Opx;

font-family : Verdana, Geneva, Arial;

font-size : llpx;

color : Maroon;

}

.txt {

padding : 0px;

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;

font-size : llpx;

color : Black;

}

.txtsearch {

padding : 0px;

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;

font-size : llpx;

background : Ie6e4dd;

text-decoration : none;

}

.txtlink {

padding : Opx;

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;

font-size : llpx;

color : #122C6D;

}

.txtact {

padding : 0px;

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;

font-size : llpx;

color : #3366CC;

}

.note {

color : #BOB368;

}

#nenu {position:absolute; left:10; top:30; width:550; height:20;
margin:0;z-index:1;}

#prompt {position:absolute; left:10; top:50; width:300;
height:30;margin:0;z-index:1;}

#basic {position:absolute; left:10; top:70; width:100%;
height:30;margin:0;z-index:1;}

#seladdr {position:absolute; left:10; top:-400; width:550; height:350;
z-index:2; }

Листинг П2.5. Код файла ie.css

.txtmenu {

color : #4B4558;

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;

font-size : llpx;

padding : 3px;

text-decoration : none;

font-weight : bold;

}
.txtmenustat {

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;

font-size : llpx;
padding : 3px;
color : #4B4558;

.title {

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;
font-weight : bold;
font-size : 15px;
color : #484558;

}
INPUT {

padding : 0px;

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;

font-size : 10px;

}
TEXTAREA {

padding : 0px;

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;

font-size : 10px;

}
.txtlink {

padding : 0px;

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size : llpx;
color : I122C6D;
text-decoration : none;
}
.txtact {

padding : Opx;

font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;

font-size : llpx;

color : #3366CC;

text-decoration : none;

Листинг П2.6. Код страницы login.cfm

<TITLE>Login</TITLE>
</HEAD>

<BODY bgcolor="<cfoutput>#Application.myBGColor#</cfoutput>">
<script>

function SendPassword() {

if(ie) var EMail = document . forml .EMail_User. value;

else var EMail =
document. layers [ 'basic' ] .document. forml .EMail_User. value;

if (EMail=="") {

alert ('Enter please Login (E-mail) ');
} else {

location. href ="sendpas sword. cfm?EMail="+EMail;

}

</script>

<CFIF IsDefined( "Session. user. id") AND Session. login eq "true">
< ! --- Пользователь уже существует

(The user is already determined) --- >

<CFQUERY NAME="VerificationUser" DATASOURCE="#Application.dsn#">
SELECT Key_User, FirstN_User, LastN_User,

EMail_User, TotalLogins_User, Pass_User
FROM UserMail

WHERE EMail_User = '#Form.EMail_User# '
</CFQUERY>
<CFIF VerificationUser.RecordCount eq 1 AND Len(Form. Pass_User)

neq 0>

<CFSET Password = Decrypt (VerificationUser. Pass_User,

VerificationUser.Key_User) >
<CFIF Form.PassJJser eq Password>
<CFSET Session. login = "true">

<CFSET Session. user. id = IVerificationUser .Key__User#>
<CFSET Session. user. name = #VerificationUser . FirstN_User# &

" " & #VerificationUser.LastN_User#>

<CFQUERY NAME="UpdateUser" DATASOURCE="#Application.dsn#">
UPDATE UserMail SET LastIP_User = '#CGI.REMOTE_ADDR#',
LastBrowser_User = '#CGI.HTTP_USER_AGENT#',
LastLogin_User = '#DateNow#',
TotalLogins_User = #TotalLoginst
WHERE Key_User = ISession.user.id#
</CFQUERY>

<TD><SPAN class="txtmenustat">
Log In I 
<A href="signup.cfm" target="_top" class="txtmenu"

onMouseOver="javascript:layerWrite('prompt',null, '<span
class=\'txtprompt\'>Sign up for reception of a Mail Box</span>');

window.status='Sign up for reception of a Mail Box';
return true"

onMouseOut="javascript:layerWrite('prompt',null,'');
window.status=''; return true">Sign Up</A> Isnbsp;
<A href="help.cfm" target="_top" class="txtmenu"

onMouseOver="javascript:layerWrite ('prompt' , null, '<span

с1ass=\ ' txtprompt\ ' >The auxiliary information<"/span> ' ) ;

window.status='The auxiliary information';
return true"

onMouseOut="javascript:layerWrite('prompt',null,'');
window.status='';
return true">Help</A>
</SPANX/TD>
</TR>
</TABLE>

</DIV>

#msgError#</TD></TR>
</CFOUTPUT>
</CFIF>

E-Mail (Login)</TD>

<TD class="note"><input name="EMail_User"

size="17"></TD>
</TR>
<TR><TD align="right" class="txtForml">

Password</TD><TD class="note">

Forgot your password?<br><A href="javascript:SendPassword();"

onMouseOver="window.status='Have it emailed to you';

return true"

onMouseOut="window.status=''; return true">
Have it emailed to you. </A></TD></TR>
</TABLE>

</FORM>
</DIV>

</CFIF>
</CFIF>
</BODY>
</HTML>

Листинг П2.7. Код страницы signup.cfm

<TITLE>Signup</TITLE>
</HEAD>

<BODY bgcolor="<cfoutput>#Application.myBGColor#</cfoutput>">
<CFIF isDefined("Session.user.id") AND Session.login eq "true">

<!--- Пользователь уже существует

(The user is already determined) --->

<CFSET msgError = msgError & "<br>" & #Application.msgErrorl#>
<CFSET DIsuccessful = 0>
</CFIF>
<CFIF Len(Form.PassJJser) le 4>

<CFSET msgError = msgError & "<br>" & #Application.msgError2#>
<CFSET DIsuccessful = 0>
</CFIF>
<CFIF IsNumeric(Form.Pass_User)>

<CFSET msgError = msgError & "<br>" & #Application.msgError3#3>
<CFSET DIsuccessful = 0>
</CFIF>
<CFIF Form.Pass_User not equal Form.Confirm>

<CFSET msgError = msgError & "<br>" & #3Application.msgError4#>
<CFSET DIsuccessful = 0>

</CFIF>

<CFSF.T msgError = msgError & "<br>" 5 #Application.msqError5#>
<CFSET DIsuccessful = 0>
</CFIF>
<CFIF Len(Form.LastN_User) le 0>

<CFSET msgError - msgError & "<br>" & #Application.msgError6#>
<CFSET DIsuccessful = 0>
</CFIF>
<CFIF YesNoFormat(DIsuccessful) equal "No">

<CFSET EMail_User = #Form.EMail_User# &

#Application.mailserver#>
<CFQUERY NAME="VerificationUser"

DATASOURCE="#Application.dsn#">
SELECT Key_User
FROM UserMail

WHERE EMail_User='#EMail_User#'
</CFQUERY>
<CFIF VerificationUser.RecordCount eq 1>

<!--- Запись с этим адресом уже существует!

(The record with this EMail

address already exists!) --->

<CFSET msgError = "The record

with this EMail address

already exists!">

<CFSET DateNow = #DateFormat(Now(),

"dd/mm/yyyy")#& " " &

#TimeFormat(Now(), "HH:mm:ss")#>
<CFQUERY NAME="AddUser"

DATASOURCE="#Application.dsn#">

INSERT INTO UserMail(EMailJJser,

FirstN_User, LastNJJser,
DateSignUp_User, LastLogin_User,
LastIP_User, LastBrowser_User,
TotalLogins_User)

VALUES('#EMail_User#', 'tForm.FirstN_Userl',

'#Form.LastN_User#', '#DateNow#',

'#DateNow#',
'#CGI.REMOTE__ADDR#',

'#CGI.HTTP_USER_AGENT#', 1)
</CFQUERY>

<CFQUERY NAME="UserExtKey" DATASOURCE="#Application.dsn#">
SELECT Key_User
FROM UserMail

WHERE EMailJJser = '§EMail_Userl'
</CFQUERY>

<CFOUTPUT QUERY="UserExtKey">
<CFSET Session.login = "true">
<CFSET Session.user.id = #UserExtKey.Key_User#>
<CFSET Session.user.name = #Form.FirstN_User# & " " &

#Form.LastN_User#>

<CFSET Password = Encrypt(Form.Pass_User, Session.user.id)>
<CFQUERY NAME="UpdatePass" DATASOURCE="#Application.dsn#">
UPDATE UserMail SET Pass_User = '#Password#'

WHERE Key_User = #Session.user.id#
</CFQUERY>

<META HTTP-EQUIV="Refresh"
CONTENT="0;URL=sendpassword.cfm?

EMail=<CFOUTPUT>ISession.user.email#

</CFOUTPUT>SType=SignUp">
<CFEXIT>
</CFIF>
</CFIF>
<CFELSE>

<a href-"loqin.cfm" targyl=" Lup" с1аяя="Г.хШепи"

onMouseOver="javascript:layerWrite ( 'prompt ' , null , '<span
cla53=\'txtprompt\'>Datd input for work with a Mail Box</span>' ) ;

window. status=' Data input for work with a Mail Box';

return true"

onMouseOut=" javascript :layerWrite ( 'prompt' , null/ ' ' ) ;

window. status=' ' ; return true">Log In</A>  | snbsp;
Sign UpSnbsp; |  
<A href="help.cfm" target="_top" class="txtmenu"

onMouseOver=" javascript : layerWrite ( 'prompt ' , null, ' <span
class=\ 'txtprompt\'>The auxiliary inf ormation</span> ' ) ;

window. status=' The auxiliary information';
return true"

onMouseOut=" javascript: layerWrite ( 'prompt ', null, ' ') ;
window. status= ' ' ; return true">Help</A>
</SPAN></TD>
</TR>
</TABLE>

</div>

#msgError#
</TD></TR>

</CFOUTPUT>
</CFIF>
<TR><TD align="right" class="txtForml">

E-Mail (Login) </TD><TD width="215" class="txtForml">

<input name="EMail User" size="10"

value="<CFOUTPUT>#email#</CFOUTPUT>"><CFOUTPUT>

#Application.mailservertt</CFOUTPUT> *</TD></TR>
<TR><TD align="right" class="txtForml">
Password</TD><TD class="txtForml">
<input type="password" name="Pass_User"

size="10">  *</TD></TR>

<TR><TD align="right" class="txtForml">
Confirm</TD><TD class="txtForml">
<input type="password" name="Conf irm"

size="10">Snbsp; *</TD></TR>
<TR><TD align="right" class="txtForml">
First Name</TD><TD class="txtForml">
<input name="FirstN_User" size="17"

value="<CFOUTPUT>#firstn#</CFOUTPUT>"> *
</TD></TR>

<TR><TD align="right" class="txtForml">
Last Name</TD><TD class="txtForml">
<input name="LastN_User" size="17"

value="<CFOUTPUT>llastnf</CFOUTPUT>"> *
</TD></TR>

</div>

</CFIF>
</BODY>
</HTML>

Листинг П2.8. Код страницы sendpassword.cfm

<CFQUERY NAME="Verification" DATASOURCE="#Application.dsnt">
SELECT Pass_User, FirstN_User, EMail_User
FROM UserMail

WHERE EMail_User = '#URL.EMail#'
</CFQUERY>

<CFSET PostMasterEMail = "Root" & #Application.mailserver#>
<CFSET Password = Decrypt(Verification.Pass_User,

Verification.Key_User)>

<CFMAIL TO="#URL.EMail#"

FROM="#PostMasterEMail#"

SUBJECT="Password"

SERVER="#Application.smtp#">

Dear #Verification.FirstN_User#

This message was sent at your request.

For work with the project "#Application.ApplicationName#",

you are registered E-Mail address(Login): #Verification.EMail_User#

with the password: #Password#

Best wishes.

</CFMAIL>
</CFIF>
<CFELSE>

<HTML>

<BODY bgcolor="<CFOUTPUT>#Application.myBGColor#</CFOUTPUT>">
<CFIF isDefined("URL.Type")>

Листинг П2.9. Код страницы edituser.cfm

</HEAD>

<BODY bgcolor="<cfoutput>#Application.myBGColor#</cfoutput>">
<CFIF isDefined("Session.user.name")>
<CFIF isDefined("Form.Pass_User")>
<CFSET DIsuccessful = l>
<CFSET msgError = "Warning Error!">
<CFIF Len(Form.Pass_User) le 4>

<CFSET msgError = msgError & "<br>" & #Application.msgError2#>
<CFSET DIsuccessful = 0>
</CFIF>
<CFIF IsNumeric(Form.Pass_User)>

<CFSET msgError = msgError & "<br>" & #Application.msgError3#>
<CFSET DIsuccessful = 0>
</CFIF>
<CFIF Form.Pass_User not equal Form.Confirm>

<CFSET msgError = msgError & "<br>" & tApplication.msgError4#>
<CFSET DIsuccessful = 0>
</CFIF>
<CFIF YesNoFormat(DIsuccessful) equal "Yes">

<CFSET Password = Encrypt(Form.PassJJser, Session.user.id)>
<CFQOERY NAME="UpdateUser" DATASOURCE="#Application.dsn#">
UPDATE UserMail

SET Pass_User = '#Password#'
WHERE EMail_User='#Session.user. email#'
</CFQUERY>

<META HTTP-EQUIV="Refresh"

CONTENT="0;URL=sendpassword.

cfm?EMail=<CFOUTPUT>#Session.user.email#
</CFOUTPUT>&Type=EditUser">
<CFEXIT>
</CFIF>
</CFIF>

<A href="mailbox.cfm" target=" top" class="txtmenu"

nnMouseOvor=javaeaript:laycrWritc('prompt',null,'<span
class=\,'rxtprompt\ '>Mail Box</span>' ) ;

window.status='Mail Box';
return true"

onMouseOut="javascript:layerWrite('prompt',null,'');
window.status=''; return true">Mail Box</A> ISnbsp;
<A href="newmail.cfm" target="_top" class="txtmenu"

onMouseOver="javascript:layerWrite('prompt',null,'<span
class=\'txtprompt\'>New Mail</span>');

window.status='New Mail'; return true"
onMouseOut="javascript:layerWrite('prompt',null,'');
window.status=''; return true">New Mail</A> | 
<A href="addresses.cfm" target="_top" class="txtmenu"

onMouseOver="javascript:layerWrite('prompt',null,'<span
class=\'txtprompt\'>Addresses</span>');

window.status='Addresses'; return true"
onMouseOut="javascript:layerWrite('prompt',null,'');
window.status='';return true">Addresses</A> | 
<A href="logout.cfm" target="_top" class="txtmenu"

onMouseOver="javascript:layerWrite('prompt',null,'<span
class=\'txtprompt\'>Log Out</span>'};

window.status='Log Out'; return true"
onMouseOut="javascript:layerWrite('prompt¹,null,'');
window.status=''; return true">Log Out</A>
</SPANX/TD>
</TR>
</TABLE>
</DIV>

<p class="title"*>Edit User

<CFOUTPUT>#Session.user.name#</CFOUTPUT></p>

<FORM action="edituser . cfm"

method="post" name="forml">

<TABLE width="315" border="0"

cellspacing="4" cellpadding="0">
<CFIF isDefined("msgError") >
<CFOUTPUT>

tmsgErrort
</TD></TR>
</CFOUTPUT>
</CFIF>
<TR><TD align="right" class="txtForml">

E-Mail (Login) </TD><TD width="215"

class="txtForml">
<CFOUTPUT>#Session.user.email#</CFOUTPUT></TD></TR>
<TR><TD align="right" class="txtForml">
Password</TD><TD class="txtForml">
<input type="password" name="Pass_User"

size="10">  *</TD></TR>
<TR><TD align="right" class="txtForml">
Confirm</TD><TD class="txtForml">
<input type="password" name="Confinn"

size="10">  *</TD></TR>
<TR><TD align="right">

</div>

Листинг П2.10. Код страницы mailbox.cfm

<CFIF isDefined("Session.user.name")>
<CFQUERY NAME="User" DATASOURCE="#Application.dsn#">
SELECT EMail_User, Pass_User
FROM UserMail

WHERE Key User=#Session.user.idtt
</CFQUERY>
<CFLOOP QUERY="User">

<CFQUERY NAME="CountNewMail" DATASOURCE="#Application.dsn#">
SELECT Key_Box
FROM MailBox
WHERE Key_User=#Session.user.id#

AND Key_TypeBox = 1 AND ReadState_Box = 0
</CFQUERY>

<BODY bgcolor="<cfoutput>#Application.myBGColor#</cfoutput>">
<script type="text/javascript" language="JavaScript"

src="selectchecks. js"></script>
<script>

function MoveDeleteSelMail(block, type, what) {
idxlen = SelUnsellnv(block);
var strCheck = "";
for (i=0;i<idxlen;i++) {
if (ns) {

if (document.layers[block].

document.form2.elements[i].checked==
true) {

if (strCheck=="") {

strCheck =
document . layers [block] .document.

form2. elements [i] .value;

} else {

strCheck = strCheck + "," +
document . layers [block] .document .

form2. elements [I] .value;

}

} else {

if (document . form2 .elements (i) .

checked==true) (
if (strCheck=="") (

strCheck = document . form2 .

elements (i) .value;
} else {

strCheck = strCheck + "," +
document. form2. elements (i) .value;

}

if (strCheck == "") {
alert ("For moving or removal it is necessary

to select even one mail!");
} else {

eval ("window. location. href =
'movedel_mail . cfm?Type="+type+"&What="+what+"&KeySel="+strCheck+" ' '

</script>

<TABLE width=440 border=0 cellpadding=0 cellspacing=0>
<TR valign="Middle">
<TDXspan class="txtmenustat">
Mail Box  |  

<A href="newmail.cfm" target="_top" class="txtmenu"
onMouseOver=" javascript: layerWrite ( 'prompt' , null,

'<span class=\'txtprompt\'>New Mail</span>';
window. status=' New Mail'; return true"

onMouseOut=" javascript : layerWrite ( ' prompt ' , null ,'')/'
window. status=' '; return true">New Mail</A>  |  
<A href="addresses. cfm" target="_top" class="txtmenu"
onMouseOver=" javascript : layerWrite ( 'prompt ' , null,

'<span class=\ ' txtprompt\ '>Addresses</span>' )
window. status=' Addresses '; return true"
onMouseOut=" javascript: layerWrite ( 'prompt ', null, ' ') ;
window. status=' ';return true">Addresses</A>  |  
<A href ="logout. cfm" target="_top"
class="txtmenu"
onMouseOver=" javascript: layerWrite ( 'prompt ' , null,

'<span class=\ 'txtpromptX '>Log Out</span>' ) ;
window. status=' Log Out'; return true"
onMouseOut=" javascript: layerWrite ( 'prompt¹ , null, ' ' ) ;
window. status= ' ' ; return true">Log Out</A>
</span></TD>
</TR>
</TABLE>

</div>

<CFQUERY NAME="NameTypeBox" DATASOURCE="#Application.dsn#">
SELECT Name_TypeBox
FROM TypeBox

WHERE Key_TypeBox=#TypeBox#
</CFQUERY>

<p class="title">Mail Box (
<CFOUTPUT QUERY="NameTypeBox">#Name_TypeBox#</CFOUTPUT>

<CFIF TypeBox eq 1><CFOUTPUT>New - #CountNewMaill</CFOUTPUT>
</CFIF>
)

<A href="edituser.cfm" class="txtlink">
<CFOUTPUT>ISession.user.namet</CFOUTPUT></A></p>
<CFIF isDefined("Order") AND isDefined("Trend")>

<CFSET Search = ''>
</CFIF>
<CFQUERY NAME="ListNameTypeBox"

DATASOURCE="#Application.dsn#">

SELECT TypeBox.Key_TypeBox, TypeBox.Name_TypeBox
FROM TypeBox

GROUP BY TypeBox.Key_TypeBox, TypeBox.Name_TypeBox
ORDER BY TypeBox.Key_TypeBox
</CFQUERY>

<CFQUERY NAME="CountTypeBox" DATASOURCE="#Application.dsn#">
SELECT TypeBox.KeyJTypeBox, Count(Mai1Вох.Кеу_ТуреВох)

AS Count_TypeBox
FROM TypeBox, MailBox
WHERE TypeBox.Key_TypeBox = MailBox.KeyJTypeBox

AND (((MailBox.Key_User)=#Session.user.id#))
GROUP BY TypeBox.Key_TypeBox
ORDER BY TypeBox.Key_TypeBox
</CFQUERY>

<CFSET CountTypeBoxArray = ArrayNew(2)>
<CFLOOP QUERY="ListNameTypeBox">
<CFSET CountTypeBoxArray[CurrentRow][1] =

Name_TypeBox[CurrentRow]>

<CFSET CountTypeBoxArray[Key_TypeBox[CurrentRow]][2] =

Count_TypeBox[CurrentRow]>
</CFLOOP>

<CFQUERY NAME="ListMail" DATASOURCE="#Application.dsn#">
SELECT MailBox.Key_Box, MailBox.To_Box, MailBox.From_Box,
MailBox.Subject_Box, MailBox.Date_Box,
MailBox.ReadState_Box
FROM TypeBox INNER JOIN MailBox
ON TypeBox.Key_TypeBox = MailBox.Key_TypeBox
WHERE (((TypeBox.Key_TypeBox)=#TypeBox#)

AND ((MailBox.Key_User)=#Session.user.idi))
AND (#ToFrom#_Box Like '%#Search#%'

OR Subject_Box Like '%#Searchtt%')
ORDER BY lOrderf;
</CFQUERY>

<FORM action="mailbox.cfm?TypeBox=<CFOUTPUT>#TypeBox#

</CFOUTPUT>"

method="post" name="forml">
<input name="Search" size="20"

value="<CFOUTPUT>ISearch#</CFOUTPUT>">
<input type="submit" value="Search">
<CFIF TypeBox eq 3>

<input type="Button" value="Empty Deleted"

onClick="javascript:location.href='emptydel.cfm'">
</CFIF>
</FORM>

<TABLE border="0" cellpadding="0" cellspacing="0">
<TR><TD colspan="2" class="txt" align="right">
Showing:
<CFSET CountPages =

Ceiling(ListMail.recordCount/Application.PageRows)>
<CFLOOP INDEX = "Pages" FROM = "1" TO = "#CountPages#">
<CFOUTPUT>

<CFSET StartP =

Pages*Application.PageRows-Application.PageRows+l>
<CFSET EndP = Pages*Application.PageRows>
<CFIF Pages eq CountPages>
<CFSET EndP = ListMail.recordCount>
</CFIF>
<CFIF Pages eq CurPage>

#StartP#-#EndP#
<CFELSE>
<A href="mailbox.cfm?CurPage

=#Pages#&StartPg=#StartP#&EndPg
=#EndP#&Search=#Search#&TypeBox=#TypeBox#"
class="txtlink">#StartP#-#EndP#</A>
</CFIF>

<TABLE border="0" cellpadding="2" cellspacing="4">
<TR><TD bgcolor="#cbccbd" height=l></TD></TR>
<TR><TD class="txt">Folder</TD></TR>
<TR><TD bgcolor="icbccbd" height=l></TD></TR>

<CFLOOP INDEX = "i" FROM - "1"

TO - #ArrayLen(CountTypeBoxArray) #>
<CFIF i eq TypeBox>
<TR><TD class="Lxtact">

<CFOUTPUT>#CountTypeBoxArray[i)

[2]#</CFOUTPUT> -
<CFOUTPUT>#CountTypeBoxArray[i]

[1] #</CFOUTPUTX/TDX/TR>
<CFELSE>
<TR><TD class="txtlink">

<CFOUTPUT>#CountTypeBoxArray

[i][2]#</CFOUTPUT> -
<A href="mailbox.cfm?TypeBo

x=<CFOUTPUT>#i#</CFOUTPUT>"
class="txtlink"><CFOUTPUT>

#CountTypeBoxArray[i][1]#</CFOUTPUT></A>
</TD></TR>

</CFIF>
</CFLOOP>
</TABLE>
</TD>

<TABLE border="0" cellpadding="2" cellspacing="4">
<TR><TD colspan="5" bgcolor="#cbccbd" -

height=lX/TDX/TR>
<TR><TD class="txt">Check</TD>

<TD class="txt"><CFOUTPUT>#ToFrom#</CFOUTPUT>
<A href="mailbox.cfm?0rder=

<CFOUTPUT>#ToFrom#</CFOUTPUT>_Box&Trend=ASC&TypeBox=
<CFOUTPUT>#TypeBox#</CFOOTPUT>">

<img src="asc.gif" alt="0rder by ASC" border='0'x/A>
<A href="mailbox.cfm?0rder=

<CFOUTPUT>#ToFrom#</CFOUTPUT>_Box&Trend=DESC&TypeBox=
<CFOUTPUT>|TypeBoxf</CFOUTPUT>">
<img src="desc.gif" alt="0rder by DESC"

border='0'x/A> Snbsp;
</TD>

<TD class="txt">Subject<A href="mailbox.cfm?0rder=

Subj ect_Box&Trend

=ASC&TypeBox=<CFOUTPUT>#TypeBox#</CFOUTPUT>">
<img src="asc.gif" alt="0rder by ASC"
border='0'></A>

<A href="mailbox.cfm?Order=Subject_BoxSTrend

=DESCSTypeBox=<CFOUTPUT>#TypeBox#</CFOUTPUT>">
<img src="desc.gif" alt="0rder by DESC"

border='0'></A>  
</TD>

<TD class="txt">Date<A href="mailbox.cfm?0rder=
Date_Box&Trend=ASC&TypeBox=
<CFOUTPUT>|TypeBoxl</CFOUTPUT>">
<img src="asc.gif" alt="0rder by ASC"

border='0'x/A>
<A href="mailbox.cfm?Order=Date_Box&Trend

=DESC&TypeBox=<CFOUTPUT>#TypeBox#</CFOUTPUT>">
<img src="desc.gif" alt="0rder by DESC"

border='0'></A> Snbsp;
</TD>

<TD olass="txt" align="center">Controls</TD>
</TR>
<TR><TD colspan="5" bgcolor="#cbccbd"

height=l></TD></TR>
<CFIF TypeBox eq 2 OR TypeBox eq 3 OR TypeBox eq 4>

The data are absent</TD></TR>
<CFELSE>
<CFLOOP QUERY="ListMail" STARTROW="#StartPg#"

ENDROW="#EndPg#">

<TRXTD class="txt" align="center">
<input type="checkbox"

value="<CFOUTPUT>#Key_Boxf</CFOUTPUT>"
name="<CFOUTPUT>#Key_Box#</CFOUTPUT>"x/TD>
<CFIF ToFrom eq "To">

<TD class="<CFIF To_Box does not contain Search
OR Search eq ''>txt

<CFELSE>txtsearch</CFIF>">

<TD class="<CFIF From_Box does not contain Search

OR Search eq ''>txt<CFELSE>txtsearch

</CFIF>"><CFOUTPUT><CFIF Read-
State_Box eq Oxbx/CFIF>#From_Box#<CFIF

ReadState_Box eq
0></b></CFIF></CFOUTPUT></TD>

</CFIF>

txtsearch</CFIF>"><A

href="view_mail.cfm?Key=<CFOUTPUT>#Key_Box#

</CFOUTPUT>&TypeBox=<CFOUTPUT>
#TypeBox#</CFOUTPUT>" class="txtlink">

<CFOUTPUT><CFIF ReadState_Box eq
0><bX/CFIF>#Subject_Box#<CFIF

ReadState__Box eq
0></b></CFIF></CFOUTPUT></A></TD>

<TD class="<CFIF Date_Box does not contain Search

OR Search eq ' '>txt<CFELSE>txtsearch</CFIF>">

href="newmail.cfm?To=<CFOUTPUT>#From_Box#

</CFOUTPOT>&Key=<CFOUTPUT>
#Key_Box#</CFOUTPUT>">

</CFIF>

<A href="newmail.cfm?To=<CFOUTPUT>#To_Box#</CFOUTPUT>
&Draft=yes&Key=<CFOUTPUT>#Key_Box#</CFOUTPUT>">
<img src="edit.gif" alt="Edit"

border='0'></A>  
</CFIF>

<A href="view_mail.cfm?Key=

<CFOUTPUT>#Key_Box#</CFOUTPUT>
&TypeBox=<CFOUTPUT>#TypeBox#</CFOUTPUT>">
<img src="view.gif" alt="View"

border=' 0' x/A> 

<A href="movedel_mail.cfm?Type=

<CFOUTPUT>#statusDel#</CFOUTPUT>
&Key=<CFOUTPUT>#Key_Box#</CFOUTPUT>">
<img src="delete.gif" alt="Delete"

border=' 0 '></A> 
<CFIF TypeBox eq 1>

<A href="movedel_mail.cfm?

Type=Move&What=5&Key=<CFOUTPUT>

#Key_Box#</CFOUTPUT>">
<img src="junk.gif" alt="Move junk"

border='0'></A> 
</CFIF>

<CFIF TypeBox eq 3 OR TypeBox eq 5>
<A href="movedel_mail.cfm?

Type=Move&What=l&Key=<CFOUTPUT>

iKey_Box#</CFOUTPUT>">
<img src="undo.gif" alt="Undo"

border='0'></A> 
</CFIF>
</TD></TR>
</CFLOOP>
</CFIF>
<TR><TD colspan="5" bgcolor="#cbccbd"

height=l></TD></TR>
<TR><TD colspan="4">
<A href="javascript:SelectAll('basic');"

class="txtlink">Select All
. </A> ,
<A href="javascript:UnselectAll('basic');"

class="txtlink">Unselect All
</A> ,
<A href="javascript:InvertChecks('basic');"

class="txtlink">
Invert Checks</A>
</TD>

<TD align="right">
<A href="javascript:MoveDeleteSelMail('basic',

'<CFOUTPUT>#statusDel#</CFOUTPUT>');">

<img src="deletesel.gif" border='0'

alt="Delete Selected"x/A> 
<CFIF TypeBox eq 1>
<A href="javascript:MoveDeleteSelMail('basic',

'Move', '5');">
<img src="junksel.gif" border='0'

alt="Move junk Selected"x/A>
</CFIF>

<A href="javascript:MoveDeleteSelMail('basic'

'Move', '1');">
<img src="undosel.gif" border='0'

alt="Undo Selected"></A>
</CFIF>
</TDX/TR>
</TABLE>
</TDX/TR>
</TABLE>
</FORM>
</DIV>

</BODY>

</HTML>
<CFELSE>

Листинг П2.11. Код страницы receiving_mail.cfm

<CFSET Date_ = #DateFormat(ParseDateTime(Date) ,

"dd/mm/yyyy")#& " " &
#TimeFormat(ParseDateTime(Date), "HH:mm:ss")#>

<CFQUERY NAME="SaveMail"

DATASOURCE="#Application.dsn#">
<CFIF FindNoCase('Content-type:

text/html', Header) gt 0>

INSERT INTO MailBox(KeyJJser,

Key_TypeBox, To_Box, From_Box,
Cc_Box, Subject_Box, Body_Box,

ReplyTo_Box,
Type Box, Date Box, ReadState Box, Header_Box,

Attachments_Box, AttachmentFiles_Box)
VALUES(#Session.user.id#, 1, '#To#' , #From#',

'#Cc#, '#Subject#', '#Body#', '#Replyto#',
'#conType#', '#Date_#, 0, '#Header#',
'#Attachments#', '#Attachmentfiles#')
</CFQUERY>
<CFPOP SERVER= #Application.pop#

USERNAME=#Login# PASSWORD=#Password# MESSAGENUMBER=1
ACTION="Delete" NAME="DelMail">
</CFOUTPUT>

Листинг П2.12. Код страницы movedel_mail.cfm

<TITLE>Move Delete MaiK/TITLE>
</HEAD>

<BODY bgcolor="<CFOUTPUT>#Application.myBGColor#</CFOUTPUT>">
<CFIF isDefined("URL.Type")>

DELETE * FROM MailBox WHERE Key_Box = #URL.Key#
</CFQUERY>
<CFELSE>

DELETE * FROM MailBox WHERE Key_Box IN (#URL.KeySel#)
</CFQUERY>
</CFIF>
</CFIF>

</HEAD>

<BODY bgcolor="<cfoutput>#Application.myBGColor#</cfoutput>">
<CFQUERY NAME="EmptyDeleteMail" DATASOURCE="#Application.dsn#">
DELETE * FROM MailBox

WHERE Key_User= #Session.user.idtt AND Key_TypeBox = 3
</CFQUERY>

Листинг П2.14. Код страницы view_mail.cfm

<CFQUERY NAME="ViewMail" DATASOURCE="#Application.dsn#">
SELECT *
FROM MailBox

WHERE Key_Box = #URL.Keyl
</CFQUERY>
<HTML>
<HEAD>

<TITLE>View MaiK/TITLE>
</HEAD>

#Application.myBGColor#</cfoutput>">
<script>
function Properties() {

eval("Variable=window.open

('properties_mail.cfm?Key=<CFOUTPUT>#URL.Keyt
</CFOUTPUT>', 'winviewmailprop',

'top=100, left=200, width=250,
height=320')");

}

</script>
<DIV id="menu">

Mail Box  |  

<A hifc;f="newnmail.cfm" Largt;L="_Lop"

onMouseOver="javascript:layerWrite

( 'prompt¹ , null, '<span
cla33=\'txtprompt\'>New Mail</span>' ) ;

window. status=' New Mail'; return
true" onMouseOut=" javascript : layerWrite

( 'prompt' ,null, ' ' ) ;
window. status=' '; return true">New Mail</A>  | Snbsp;

<A href="addresses.cfm" target="_top" class="txtmenu"

onMou5eOver=" javascript : layerWrite ( 'prompt' , null, '<span

class=\'txtprompt\'>Addresses</span>' )

; window. status=' Addresses '; return
true" onMouseOut=" javascript : layerWrite

( 'prompt ', null, ' ') ;
window. status=' '; return true">Addresses</A>  | Snbsp;

<A href="logout .cfm" target="_top" class="txtmenu"

onMouseOver=" javascript: layerWrite ( 'prompt' , null, '<span
class=\ ' txtpromptX '>Log Out</span>' ) ; window. status=' Log Out'; return
true" onMouseOut=" javascript: layerWrite ( 'prompt ', null, ' ') ;
window. status=' '; return true">Log Out</A>

</span></TD>
</TR>
</TABLE>

<CFQUERY NAME="TypeBox" DATASOURCE="#Application.dsn#">
SELECT TypeBox . Name_TypeBox
FROM TypeBox

WHERE Key_TypeBox = #URL . TypeBoxt
</CFQUERY>

<CFQUERY NAME="LMail" DATASOURCE="#Application. dsn#">
SELECT Key_Box
FROM MailBox
WHERE Key_TypeBox = #URL . TypeBoxf

AND Key_User=#Session.user.id#
</CFQUERY>
<CFSET ListMail = ValueList (LMail.Key_Box) >

#URL.TypeBox#</CFOUTPUT>">
<CFOUTPUT>#TypeBox.Name TypeBox#</CFOUTPUT

/A> ( View Mail )

<A href="edituser.cfm" class="txtlink">
<CFOUTPUT>#Session . user . name#</CFOUTPUT></A>

</p>

<TABLE width="550" border="0" cellspacing="4"

cellpadding="0">
<TR><TD align="right" class="txt" colspan="2">
<CFOUTPUT>

<CFIF ListFind(ListMail, URL. Key) gt 1>
<A href="view_mail.cfm?Key=#ListFirst (ListMail) #

&TypeBox=#URL.TypeBox#">

<img src="first .gif " alt="First" border=' 0 '></A> 
<A href="view_mail.cfm?Key=

#ListGetAt (ListMail, ListFind (ListMail, URL. Key) -1)
# &TypeBox=#URL . TypeBox# " >
<img src="preview.gif " alt="Preview"

bprder= ' 0 ' ></A> 
</CFIF>

#bistFind (ListMail, URL. Key) # of

#ListLen (ListMail) #
<CFIF ListFind (ListMail, URL. Key)

It ListLen (ListMail) >

<CFOUTPUT>#ViewMail . From_Box#</CFOUTPUT></TD></TR>
<TR><TD align="right" class="txtForml">To: </TD>
<TD class="txt" width="450">

<CFOUTPUT>#ViewMail . To_Box#</CFOUTPUTX/TDX/TR>
<TR><TD align="right" class="txtForml">Date : </TD>
<TD class="txt">

<CFOUTPUT>#ViewMail . Date_Box#</CFOUTPUTX/TDX/TR>
<TR><TD align="right" class="txtForml">Subject : </TD> '

<CFOUTPUT>#ViewMail. Subject_Box#</CFOUTPUT></TD></TR>
<TRXTD align="right" class="txtForml">Cc: </TD>
<TD class="txt">

<CFOUTPUT>#ViewMail. Cc_Boxt</CFOUTPUT></TD></TR>
<TRXTD align="right" class="txtForml">Bcc: </TD>
<TD class="txt">

<CFOUTPUT>#ViewMail. Bcc_Box#

</CFOUTPUT></TD></TR>
<TR><TD colspan="2" bgcolor="#cbccbd"

height=l></TD></TR>
<TR><TD class="txt" colspan="2">
<CFOUTPUT>
<CFIF ViewMail.Type_Box neq "HTML">

#ViewMail.Body_Box#

<TR><TD colspan="2" bgcolor="#cbccbd"

height=l></TD></TR>
<TR><TD align="right" class="txt"

colspan="2">
<CFIF ViewMail.Key_TypeBox eq 4>

#ViewMail.To_Box#</CFOUTPUT>&Draft=yes&Key
=<CFOUTPUT>#ViewMail.Key_Box#</CFOUTPUT>">

</A> snbsp;
</CFIF>

<CFIF ViewMail.Key_TypeBox eq 2 OR ViewMail.Key_TypeBox eq 3

OR ViewMail.Key_TypeBox eq 4>

<CFIF ViewMail.Key_TypeBox eq 1 OR ViewMail.Key_TypeBox eq 3

OR ViewMail.Key_TypeBox eq 5>

#ViewMail.From_Boxl</CFOUTPUT>&Key=

<CFOUTPUT>#ViewMail.Key_Box#</CFOUTPUT>">

<img src="reply.gif" alt="Reply" border='0'

/A> Snbsp;
</CFIF>

#statusDel#</CFOUTPUT>&Key=

<CFOUTPUT>#ViewMail.Key_Box#</CFOUTPUT>">

<A href ="movedel_mail . cfm?Type=Move&What=5&Key=<CFOUTPUT>#ViewMail . Key_Box#
</CFOUTPUT>">

<A href="movedel_mail . cfm?Type=Move&What=lSKey=<CFOUTPOT>#ViewMail . Key_Box#
</CFOUTPUT>">

<TR><TD align="right" class="txtForml" valign="top">Attachments :
</TD>
<TD>
<CFLOOP INDEX="i" LIST=#ViewMail . AttachmentFiles_Box#

DELIMITERS=iChr ( 9 } #>
<CFOUTPUT>

<input type="Button" value="Properties"

onClick=" javascript: Properties () ; ">
</FORM>
</TD></TR>
</TABLE>

</div>

<CFQUERY NAME="SetReadStateMail" DATASOURCE="#Application. dsn#">
UPDATE MailBox

SET ReadState_Box = 1
WHERE Key_Box = #URL.Keyl
</CFQUERY>
</CFIF>

</BODY>

</HTML>

</CFIF>
<CFELSE>

Листинг П2.15. Код страницы properties_mail.cfm

<CFQUERY NAME="PropertiesMail"

DATASOURCE="#Application.dsn#">
SELECT ReplyTo_Box, Header_Box
FROM MailBox

WHERE Key_Box = #URL.Keyl
</CFQUERY>
<HTML>
<HEAD>

<TITLE>Properties MaiK/TITLE>
</HEAD>

<BODY bgcolor="<cfoutput>#Application

.myBGColor#</cfoutput>">
<TABLE width="100%" border="0"

cellspacing="4" cellpadding="0">
<TD><TR class="txt">

<CFOUTPUT>#PropertiesMail. Header_Box#

</CFOUTPUT></TD></TR>

<CFOUTPUT>#PropertiesMail. ReplyTo_Box#

</CFOUTPUT></TD></TR>
</TABLE>

</BODY>
</HTML>
</CFIF>
<CFELSE>
<script>

window.close();
</script>
</CFIF>

Листинг П2.16. Код страницы newmail.cfm

<CFIF Form.SaveDraft eq "No" AND

Form.UpdateDraft eq "No">
<CFMAIL TO="#Form.To#"
FROM="#Form.From#"
CC="#Form.Cc#"
BCC="|Form.Bcc#"
SUBJECT="ttForm.Subject#"
SERVER="IApplication.smtp#"
TYPE="#Form.Type#"
MIMEATTACH="#Form.Attl#">
#Form.Body#

<CFSET DateNow = tDateFormat(Now(),

"dd/mm/yyyy")#& " " &
#TimeFormat(Now(), "HH:mm:ss")#>

<CFQUERY NAME="SaveMail" DATASOURCE="#Application.dsn#">
UPDATE MailBox

SET To_Box = '#Form.To#',
Cc_Box = '#Form.Cc#',
Bcc_Box = '#Form.Bcc#',
Subject_BoM = '#Form.Subject#'
Dody_Box = '#Form.Body#',
Type_Box = ' #Form. Type# ',
Date__Box = '#DateNow#',

AttachmentFiles_Box = '#AttachmentFiles#'
WHERE Key_Box = #Form.KeyBox#
</CFQUERY>
<CFELSE>
<CFQUERY NAME="SaveMail" DATASOURCE="#Application.dsn#">

INSERT INTO MailBox(Key_User, Key_TypeBox, To_Box, From_Box,
Cc_Box, Bcc_Box, Subject_Box, Body_Box,
Type_Box, Date_Box, ReadState_Box,
AttachmentFiles_Box)

VALUES(#Session.user.id#, #TypeBox#, '#Form.To#', 'iForm.Fromtt',
'#Form.Cc#', '#Form.Bcc#', '#Form.Subject*', '#Form.Body*',
'#Form.Type#', '#DateNow#', 1,
'#AttachmentFiles#')
</CFQUERY>
</CFIF>

<META HTTP-EQUIV="Refresh"

CONTENT="0;URL=mailbo*.cfm">
<CFEXIT>
</CFIF>
<HTML>
<HEAD>

#Application.myBGColor#</cfoutput>">

language="JavaScript"

src="selectchecks. js"></script>
<script>

function init() (
}

function Displacement(top, left) (
if(ns) {

document . layers [' seladdr' ]. top = top;
document . layers [ 'basic' ]. left = left;
} else {

document .all [ 'seladdr ']. style. top = top;
document. all [ 'basic' ] .style. left = left;

}

function SelAddr (field, block) {

if(ns) document . layers [block] .document .

form3 . field. value = field;
else document . form3. field. value = field;
Displacement (70, -777);
}

function Cancel ( ) (
Displacement (-400, 10);
}

function Done,(block_, block) {
idxlen = SelUnsellnv (block) ;
var strToCcBcc = "";
for (i=0;i<idxlen;i++) {
if (ns) {

if (document. layers [block] .document .

fonn2 .elements [i] .checked==
true) {

if (strToCcBcc=="") {

StrToCcBcc = docu-
ment, layers [block] .document . form2 .

elements [i] .value;

} else {

StrToCcBcc = strToCcBcc + "; " +

document. layers [block] .document. form2

.elements [i] .value;

}

} else {

if (document. form2. elements (i) .checked==true) {
if (strToCcBcc=="") (

strToCcBcc = document. form2 .elements (i) .value;
} else {
strToCcBcc = StrToCcBcc + "; " +

document. form2 .elements (i) .value;

if (strToCcBcc == "") {

alert ("For application it is

necessary to select even one address!");
} else {

if(ns) field = document. layers [block]

.document. form3. field. value;
else field = document . form3 . field. value ;

if (ns) eval ("document. layers [block_]

.document. forml . "+field+" .value
'" + StrToCcBcc +"'");

else eval ("document. forml. "+field+".

value = '" + StrToCcBcc +"'");
Displacement (-400, 10);

}

function DoneCur (block_, block, EMail) {

if(ns) field = document . layers [block] .

document . form3 . field. value;
else field = document. form3. field. value;
if (ns) eval ("document. layers [block_]

.document . forml . "+field+". value

¹¹¹ + EMail +'"") ;

else eval ("document. forml. "+field+".

value = '" + EMail +"'");
Displacement (-400, 10);
}

function IsForml(fr) {

if ( f r . To . value . length==0 ) {
alert ("Please, enter field - 'To'");
return false;

}

function IsForm3(fr, block_) {

if(ns) Root = "document . layers [block_]

.document . forml"
else Root = "document . forml "

eval ("fr. Subject. value =

"+Root+" . Subject .value") ;
eval ("fr. To. value = "+Root+" .To. value") ;
eval ("fr. Cc. value = "+Root+" .Cc. value") ;
eval ("fr. Вcс. value = "+Root+" .Вес. value") ;
eval ("fr. Body. value = "+Root+" .Body. value") ;
eval ("fr. Type. value = "+Root+" .Type. value") ;

return true;
}

function TypeClick(val, block_) {

if(ns) document.layers[block_].

document.forml.Type.value = val;
else document.forml.Type.value = val;
}
function SDraft(block_) {

if(ns) document.layers[block_].

document.forml.SaveDraft.value =

"Yes";

else document.forml.SaveDraft.value = "Yes";
}
function UDraft(block_) {

if(ns) document.layers[block_].

document.forml.UpdateDraft.value

"Yes";

else document.forml.UpdateDraft.value = "Yes";
}
</script>

<CFIF isDefined("Form.Search")

OR isDefined("URL.CurPage")>
<CFOUTPUT>
<script>

function init() {Displacement(70, -777);}
</script>
</CFOUTPUT>
</CFIF>

<TABLE width=440 border=0 cellpadding=0 cellspacing=0>
<TR valign="Middle">
<TD><span class="txtmenustat">
<A href="mailbox.cfm" target="_top" class="txtmenu"

onMouseOver="javascript:layerWrite('prompt',null,'<span
class=\'txtprompt\'>Mail Box</span>');

window.status='Mail Box'; return true"

onMouseOut="javascript:layerWrite('prompt',null,'');

window.status=''; return true">Mail Box</A>  | Snbsp;

New Mail ISnbsp;

<A href="addresses.cfm" target="_top" class="txtmenu"

onMouseOver="javascript:layerWrite('prompt', null,'<span

Class=\ 'txtprompt\ ' >Addresses</span> ' ) ;

window.status='Addresses'; return true"
oriMouseOut="javascript:layerWrite('prompt',null,'');
window.status=''; return true">Addresses</A>&nb3p;| 
<A hief="loguuL.<jfm" target="_top" class="txtme>nu"

onMouseOver="javascript:layerWrite('prompt',null,'<span
class=\'txtprompt\'>Log Out</span>'(;

window.status='Log Out'; return true"
onMouseOut="javascript:layerWrite('prompt',null,'');
window.status=''; return true">Log Out</A>
</spanx/TD>
</TR>
</TABLE>
</DIV>

<CFQUERY NAME="EditMail" DATASOURCE="#Application.dsn#">
SELECT *
FROM MailBox

WHERE Key_Box = iURL.Keytt
</CFQUERY>

<DIV id="basic">
<p class="title">New Mail
<A href="edituaer.cfm" class="txtlink'">
<CFOUTPUT>#Session.user.name#</CFOUTPUT></A></p>

<FORM action="riewmail.cfm?SendType=SendMail"

method="post" name="forml" onSubmit="return IsForml(this);">
<TABLE width="400" border="0" cellspacing="4" cellpadding="0">
<CFIF isDefined("msgError")>
<CFOUTPUT>
<TRXTD colspan="2" align="center" class="txtError">

#msgError#
</TD></TR>
</CFOUTPUT>
</CFIF>
<TR>

<TD align="right" class="txtForml">From</TD>
<TD class="txtForml">
<input name="From" size="20" readonly="Yes"

value="<CFOUTPUT>#Session.user.email#</CFOUTPUT>">
</TD></TR>

<TR><TD align="right" class="txtForml">
<A href="javascript:SelAddr('To', 'seladdr');" -

class="txtlink">To</A></TD><TD class="txtForml">
<input name="To" size="56"

value="<CFOUTPUT>#to#</CFOUTPUT>">Snbsp;*</TD></TR>
<TR><TD "align="right" class="txtForm1">Subject</TD>

<TD class="txtForml"><input name="Subject" size="56"

value="<CFOUTPUT>#subject#</CFOUTPUT>"X/TD></TR>
<TR><TD align="right" class="txtForml">

<A href="javascript:SelAddr{'Cc', 'seladdr');"

class="txtlink">Cc</A></TD><TD class="txtForml">
<input name="Cc" size="56"

value="<CFOUTPUT>#ccl</CFOUTPUT>"></TD></TR>

<A href="javascript:SelAddr('Вес', 'seladdr');"

class="txtlink">Bcc</A></TD><TD class="txtForml">

<input name="Bcc" size="56"

value="<CFOUTPUT>#bcc#</CFOUTPUT>"></TD></TR>
<TR><TD class="txtForml" colspan="2">
<textarea name="Body" rows="8"

cols="71"><CFOUTPUT>#body#

</CFOUTPUT></textarea></TD></TR>
<TR><TD align="right"

class="txtForml">Type</TD>

<input type="radio" name="Type"
onClick="TypeClick('', 'basic')"
value=""<CFOUTPUT>#type1#

</CFOUTPUT>>plain text
<input type="radio" name="Type"

onclick='.'TypeClick( 'HTML', 'basic') "

value="HTML"<CFOUTPUT>ltype2#

</CFOUTPUT>>html</TD></TR>
<TR><TD align="right"

class="txtForml">Attachmentl</TD><TD>
<input class="txtForml"

type="file" name="attl"

size="36"></TD></TR>

<TR><TD al'ign="right"

class="txtForml">

Attachment2</TD><TD>
<input class="txtForml"

type="file" name="att2"

size="36"></TD></TR>

<TR><TD align="right" class="txtForml">Attachment3</TD><TD>
<input class="txtForml" type="file" name="att3"

size="36"></TD></TR>
<TR><TD align="right"><input type="submit"

value="Send"></TD><TD><input type="reset" value="Clear">
<CFIF isDefined("URL.Draft")>
<input type="submit" value="Update Draft"

onClick="UDraft('basic')">
<CFELSE>
<input type="submit" value="Save Draft"

onClick="SDraft('basic')">
</CFIF>

<input type="Hidden" name="SaveDraft" value="No">
<input type="Hidden" name="UpdateDraft" value="No">
<input type="Hidden" name="KeyBox"

value="<CFOUTPUT>#keybox#</CFOUTPUT>">
</TD></TR>
</TABLE>
</FORM>

At change of the block of pages or sorting the

parameters of the letter are not kept!</i>

<CFQUERY NAME="Addresses" DATASOURCE="#Application.dsn#">
SELECT Key_Addr, FirstN_Addr, LastN__Addr,

Company_Addr, EMail_Addr, Phone_Addr
FROM Addresses

WHERE Addresses.Key_User = #Session.user.id#

AND (FirstN_Addr Like '%#Searcht%' OR LastN_Addr Like '%#Searchtt%'
OR Company_Addr Like '%#Search#%' OR EMail_Addr Like '%#Search#%')
ORDER BY #Order#
</CFQDERY>

<FORM action="newmail.cfm" method="post" name="form3"

onSubmit="IsForm3(this, 'basic')">
<input name="Search" size="20"

value="<CFOUTPUT>#Search#</CFOUTPUT>">
<input type="submit" value="Search">
<input type="Button" value="Done"

onClick="javascript:Done('basic', 'seladdr');">
<input type="Button" value="Cancel"

onClick="javascript:Cancel();">
<input type="Hidden" name="field">
<input type="Hidden" name="Subject">
<input type="Hidden" name="To">

<TABLE border="0" cellpadding="2" cellspacing="4">
<TR><TD colspan="6" class="txt" align="right">
Showing:
<CFSET CountPages =

Ceiling(Addresses.recordCount/Application.PageRows)>
<CFLOOP INDEX = "Pages" FROM = "1" TO = "#CountPages#">
<CFOUTPUT>

#StartP#-#EndP#
<CFELSE>

href="newmail.cfm?CurPage=#Pages#

&StartPg=#StartP#&EndPg=#EndP#SSearch=#S

earcht" class="txtlink">#StartP#-#EndP#</A>

</CFIF>

<CFIF Pages eq Application

.MaxLinePages*CurBlockPages>
<CFSET CurBlockPages = CurBlockPages + 1>
<br>
</CFIF>
</CFOUTPUT>
</CFLOOP>
</TD></TR>

<TR><TD colspan="6" bgcolor="#cbccbd"

height=l></TD></TR>
<TR>

<TD class="txt">To/Cc/Bcc</TD>
<TD class="txt">First

<img src="desc.gif" alt="0rder by DESC"

border='0'></A>£nbsp; 
</TD>

<TD class="txt">Last

<img src="desc.gif" alt="0rder by DESC",

border=' 0 'X/A>  Snbsp;
</TD>

<TD class="txt">Company

<A href="newmail.cfm?Order=Company_Addr&Trend=ASC">
<img src="asc.gif" alt="0rder by ASC" border='0'></A>
<A href="newmail.cfm?Order=Company_Addr&Trend=DESC">
<img src="desc.gif" alt="0rder by DESC" border='0'></A> Snbsp;
</TD>

<TD class="txt">EMail

<TD class="txt">Phone</TD>
</TR>

<input type="checkbox"
value="<CFOUTPUT>#EMail_Addr|</CFOOTPUT>"
name="<CFOUTPUT>#Key_Addrl</CFOUTPUT>"></TD>

<TD class="<CFIF FirstN_Addr does not

contain Search OR Search eq
' '>txt<CFELSE>txtsearch</CFIF>">

<CFOUTPUT>#FirstN_Addr#</CFOUTPUT></TD>

<TD class="<CFIF LastN_Addr does

not contain Search OR Search eq
' '>txt<CFELSE>txtsearch</CFIF>">

<CFOUTPUT>#LastN_Addr#</CFOUTPUT></TD>

<TD class="<CFIF Company_Addr does

not contain Search OR Search eq
' '>txt<CFELSE>txtsearch</CFIF>">

<CFOUTPUT>#Company_Addr#</CFOUTPUT></TD>

<TD class="<CFIF EMail_Addr does

not contain Search OR Search eq
' '>txt<CFELSE>txtsearch</CFIF>">

<A href=" javascript :DoneCur ( 'basic' ,
' seladdr ' , ' <CFOUTPUT># EMail_Addrtt

</CFOUTPUT> ' ) ; " class="txtlink">

<CFOUTPUT>#EMail_Addrl</CFOUTPUT></A></TD>

<TD class="txt"><CFOUTPUT>#Phone_

Addr#</CFOUTPUT></TD>
</TR>
</CFLOOP>

<TR><TD colspan="6" bgcolor="#cbccbd"

height=l></TD></TR>
<TR><TD colspan="5">
<A href =" javascript :SelectAll

( 'seladdr ');" class="txtlink">

Select All</A>  ,
<A href="javascript:UnselectAll( 'seladdr' )

; " class="txtlink">

Unselect All</A>  ,
<A href=" javascript : InvertChecks

( 'seladdr ') ;" class="txtlink">

Invert Checks</A>
</TD></TR>
</TABLE>
</FORM>

</div>

if(ns) docu-

ment . layers [ ' basic ' ] .

document . f orml . Type . value="<CFOUTPUT>#typeVal#
</CFOUTPUT>";

else document . f orml . Type .

value="<CFOUTPUT>#typeValt</CFOUTPUT>" ;

if(ns) document, layers [ 'seladdr' ]

.document . formS . field. value="<CFOUTPUT>#field#
</CFOUTPUT>" ;

else document.form3.field.value="

<CFOUTPUT>#field#</CFOUTPUT>'
</Script>

</BODY>

</HTML>
<CFELSE>

Листинг П2.17. Код страницы addresses. cfm

<TITLE>Addresses</TITLE>
</HEAD>

<BODY bgcolor="<cfoutput>#Application.

myBGColor#</cfoutput>">
<script type="text/javascript"

language=" JavaScript"

src="selectchecks . js"></script>
<script>

function SelCheck (block, delimiter, property) {

idxlen = SelUnsellnv (block) ;

var strCheck = "";
for (i=0;i<idxlen;i++) {
if(ns) {

if
(document. layers [block] .document

. form2 .elements [i] .checked==true) {

if (strCheck=="") (

eval ( "strCheck = document .

layers [block] . document. form2.

elements [i] . "+property) ;

} else {

eval ("strCheck = strCheck +

delimiter + docu-
ment . layers [block] . document.

form2. elements [i] . "+property) ;

}

} else {

if (document. form2. elements (i)

. checked==true) {
if (strCheck=='"^r) {

eval ("strCheck = document .

form2 .elements (i) . "+property) ;
} else {

eval ("strCheck = strCheck + delimiter +

document . form2 . elements (i) . "+property) ;

}

return strCheck;
}
function DeleteSelAddr (block) {

strCheck = SelCheck (block, "," , "name");

if (strCheck == "") {

alert ("For removal it is necessary

to select even one address!")

} else {

eval ("window. location. href = 'delete-

seladdr . cfm?DelAddr="+strCheck+" "' ) ;

}

function NewMailSelAddr (block) {

strCheck = SelCheck (block, ";" , "value");
if (strCheck = "") {

alert ("For creation of the new

mail it is necessary

to select even one address!");
} else {

eval ("window. location. href = 'newmail.

cfm?To="+strCheck+" ' ") ;

}

</script>

<TABLE width=440 border=0 cellpadding=0

cellspacing=0>
<TR valign="Middle">
<TDXspan clas5="txtmenustat">

<A href="mailbox.cfm" target="_top"

class="txtmenu"
onMouseOver="javascript:layerWrite

( 'prompt' ,null, '<span
class=\'txtpromptX ' >Mail Box</span> ' ) ;

window. status=' Mail Box'; return true"

onMouseOut="javascript:layerWrite

( 'prompt ' /null, ' ') ;
window. status- ' ' ; return true">Mail

Box</A>  |  
<A href="newmail.cfm" target="_top"

class="txtmenu"

OnMouseOver=" javascript : layerWrite ( 'prompt ' , null, ' <span
elass=\ ' txtpromptX ' >New Mail</span> ' ) ;

window. status=' New Mail¹; return true"
onMouseOut=" javascript: layerWrite ( 'prompt' , null, ' ' ) ;
window. status=' '; return true">New Mail</A>  I Snbsp;
AddressesSnbsp; |  

<A href="logout.cfm" target="_top" class="txtmenu"
onMouseOver=" javascript : layerWrite ( 'prompt ' , null, ' <span
class=\ ' txtpromptX ' >Log Out</span> ' ) ;

window. status=' Log Out'; return true"
onMouseOut=" javascript: layerWrite ( 'prompt' , null, ' ') ;
window. status= ' ' ; return true">Log Out</A>
</spanx/TD>
</TR>
</TABLE>

</div>

<DIV id="basic">
<p class="title">Addresses
<A href="edituser.cfm" class="txtlink">
<CFOUTPUT>#Session . user . name#</CFOUTPUTX/AX/p>

SELECT Key_Addr, FirstN_Addr, LastN_Addr,

Company Addr, EMail Addr, Phone Addr

FROM Addresses

WHERE Addresses.Key_User = #Session.user.id#

AND (FirstN_Addr Like '%tSearch#%' OR LastN_Addr Like '%#Searcht%'
OR Company_Addr Like '%#Search#%' OR EMail_Addr Like '%#Searchf%')

ORDER BY #0rder#
</CFQUERY>

<input name="Search" size="20"

value="<CFOUTPUT>#Search#</CFOUTPUT>">

<input type="Button" value="New Contact"

onClick="javascript:location.

href='addeditdel_addr.cfm?Type=Add'">

<input type="Button" value="New Mail for Selected"

onClick="javascript:NewMailSelAddr('basic');">
</FORM>

<TRXTD colspan="7" class="txt" align="right">
Showing:

<CFSET StartP = Pages*Application.

PageRows-Application.PageRows+l>

#StartP#-#EndP#
<CFELSE>

<A href="addresses.cfm?CurPage=

#Pages#&StartPg=#StartP#&EndPg=#EndP#&Search=

#Search#" class="txtlink">#StartP#-#EndP#</A>

</CFIF>

<CFIF Pages eq Application.

MaxLinePages*CurBlockPages>
<CFSET CurBlockPages = CurBlockPages + 1>
<br>
</CFIF>
</CFOUTPUT>
</CFLOOP>
</TD></TR>

<TR><TD colspan="7" bgcolor="#cbccbd"

height=l></TD></TR>
<TR><TD class="txt">To</TD>
<TD class="txt">First

<A href="addresses.cfm?Order=FirstN

_Addr&Trend=ASC">
<img src="asc.gif" alt="0rder by

ASC" border='0'x/A>
<A href="addresses.cfm?Order=FirstN

_Addr&Trend=DESC">
<img src="desc.gif" alt="0rder by

DESC"

border='0'></A> Snbsp;</TD>
<TD class="txt">Last

<A href="addresses.cfm?Order=LastN

_Addr&Trend=ASC">
<img src="asc.gif" alt="0rder by

ASC" border='0'></A>
<A href="addresses.cfm?Order=LastN

_Addr&Trend=DESC">
<img src="desc.gif" alt="0rder by DESC"

border='0'></A>  
</TD>

<TD class="txt">Company

<A href="addresses.cfm?Order=Company

_Addr&Trend=ASC">
<img src="asc.gif" alt="0rder by ASC"

border='0'></A>
<A href="addresses.cfm?Order=Company

_Addr&Trend=DESC">
<img src="desc.gif" alt="0rder by DESC"
border='0'></A> Snbsp;</TD>

<TD class="txt">EMail

<A href="addresses.cfm?Order=EMail_

Addr&Trend=ASC">
<img src="asc.gif" alt="0rder by ASC"

border='0'x/A>
<A href="addresses.cfm?Order=EMail_

Addr&Trend=DESC">
<img src="desc.gif" alt="0rder by DESC"

border='0'></A> Snbsp;</TD>
<TD class="txt">Phone</TD>

<TD class="txt" align="center">Controls</TD>
</TR>

<TR><TD colspan="7" bgcolor="icbccbd"

height=lx/TDX/TR>
<FORM method=?"post" name="form2">
<CFIF Addresses.recordCount eq 0>
<TR><TD class="txt" colspan="7" align="center">

The address book is empty</TDX/TR>
<CFELSE>

<CFl,OOP QUERY="Addresses" STARTROW="

#StartPg#" ENDROW="#EndPg#">
<TR>
,<TD class="txt"Xinput type="checkbox"

value="<CFOUTPUT>#EMail_Addr#</CFOUTPUT>"

name="<CFOUTPUT>#Key_Addr#</CFOUTPUT>"

/TD>
<TD class="<CFIF FirstN_Addr does not

contain Search OR

Search eq ''>txt<CFELSE>txtsearch</CFIF>">

<CFOUTPUT>#FirstN_Addr#</CFOUTPUTX/TD>

<TD class="<CFIF LastN_Addr does not

contain Search OR

Search eq ''>txt<CFELSE>txtsearch</CFIF>">

<CFOUTPUT>iLastN_Addr#</CFOUTPUTX/TD>

<TD class="<CFIF Company_Addr does

not contain Search OR

Search eq ''>txt<CFELSE>txtsearch</CFIF>">

<CFOUTPUT>#Company_Addr#</CFOUTPUT></TD>

<TD class="<CFIF EMail_Addr does not contain Search OR

Search eq ''>txt<CFELSE>txtsearch</CFIF>">

<A href="newmail.cfm?To=<CFOUTPUT>IEMail_Addr

#</CFOUTPUT>"

class="txtlink"XCFOUTPUT>#EMail_Addrtt

</CFOOTPUT></A></TD>
<TD class="txt"><CFOUTPUT>#Phone_Addr#

</CFOUTPUTX/TD>
<TD class="txt" align="center">
<A href="addeditdel_addr.cfm?Type=Edit&Key=<CFOUTPUT>

#Key_Addr#</CFOUTPUT>">
<img src="edit.gif" alt="Edit" border='0'x/A> Snbsp;

#Key_Addr#</CFOUTPUT>">

<A href="javascript:SelectAll('basic');"
class="txtlink">Select All</A> ,
<A href="javascript:UnselectAll('basic');"
class="txtlink">Unselect All</A> ,
<A href="javascript:InvertChecks('basic');"

class="txtlink">Invert Checks</A>
</TD>

</BODY>

</HTML>
<CFELSE>

Листинг П2.18. Код страницы addeditdel_addr.cfm

<HEA'D>

<TITLE><cfoutput>#Type#</cfoutput> Addresses</TITLE>
</HEAD>

<BODY bgcolor="<CFOUTPUT>#Application.myBGColor#</CFOUTPUT>">
<DIV id="menu">

<TABLE width=440 border=0 cellpadding=0 cellspacing=0>
<TR valign="Middle"><TD><span class="txtmenustat">
<A href ="mailbox. cfm" target="_top" class="txtmenu"
onMouseOver=" javascript : layerWrite ( 'prompt ' , null,

'<span class=\'txtprompt\'>Mail Box</span>';
window. status=' Mail Box'; return true"
onMouseOut=" javascript: layerWrite ( 'prompt' , null, ' ' ) ;
window. status= ' ' ; return true">Mail Box</A>  | snbsp;
<A href="newmail.efm" target="_top" class="txtmenu"
onMouseOver=" javascript : layerWrite ( 'prompt ' , null,

'<span class=\' txtprompt\ '>New Mail</span>';
window. status=' New Mail'; return true"
onMouseOut=" javascript: layerWrite ( 'prompt ', null, ' ') ;
window, status=' '; return true">New Mail</A>  |  
Addresses  | Snbsp;

<A href="logout.cfm" target="_top" class="txtmenu"
onMouseOver=" javascript: layerWrite ( 'prompt' , null,

'<span class=\'txtprompt\'>Log Out</span>' ) ;
window. status=' Log Out'; return true"
onMouseOut="javascript:layerWrite ( 'prompt' , null, ' ') ;
window. status= ' ' ; return true">Log Out</A>
</span></TD>
</TR>
</TABLE>

</div>

<p class="title"><CFOUTPUT>#Type#</CFOUTPUT>
<A href="addresses . cfm">Addresses</A>
<A href ="edituser. cfm" class="txtlink">
<CFOUTPUT>#Session . user . namet</CFOUTPUT></A></p>
<CFIF isDefined("Form.EMail")>
<CFSET DIsuccessful = 1>
<CFSET msgError = "Warning Error! ">

<CFIF Len (Form.EMail) le 5 and Form.EMail does not contain "@">
<CFSET msgError = msgError & "<br>" S #Application.msgErrorl#>

<CFQUERY NAME="EditAddr" DATASOURCE="#Application.dsn#">
UPDATE Addresses
SET EMail_Addr = '#Form.EMail#',
FirstN_Addr = '#Form.FirstN#',
LastN_Addr = '#Form.LastN#',
Company_Addr = '#Form.Company#',
Phone_Addr = '#Form.Phone#'
WHERE Key_Addr = #Key#
</CFQUERY>
<CFELSE>

<CFQUERY NAME="AddAddr" DATASOURCE="IApplication.dsn#">
INSERT INTO Addresses(Key_User, EMail_Addr, FirstN_Addr,

LastN_Addr, Company_Addr, Phone_Addr)
VALUES(#Session.user.id#, '#Form.EMail#', '#Form.FirstN#',

'#Form.LastN#', '#Form.Company*','fForm.Phone#')
</CFQUERY>
</CFIF>

SELECT *
FROM Addresses
WHERE Key_Addr = #URL.Key#
</CFQUERY>

DELETE * FROM Addresses WHERE Key_Addr = #URL.Key#
</CFQUERY>

#msgError#</TDX/TR>
</CFOUTPUT>
</CFIF>
<TRXTD align="right" class="txtForml">

First Name</TD><TD class="txtForml">
<input nome="FirstN" size-"17"

value="<CFOUTPUT>#firstn#</CFOUTPOT>"></TD></TR>
<TR><TD align-"right" class="txtForml">
Last Name</TD><TD class="txtForml">
<input name="LastN" size="17"

value="<CFOUTPUT>#lastn#</CFOUTPUT>"></TD></TR>
<TR><TD align="right" class="txtForml">
Company</TD><TD width="215" class="txtForml">
<input name=" Company" size="25"

value="<CFOUTPUT>#comp#</CFOUTPUT>"></TD></TR>
<TRXTD align="right" class="txtForml">
E-Mail</TD><TD width="215" class="txtForml">
<input name="EMail" size="25"

value="<CFOUTPUT>#emailtt</CFOUTPUT>"> *</TD></TR>
<TR><TD align="right" class="txtForml">
Phone</TDXTD class="txtForml">
<input name="Phone" size="12"

value="<CFOUTPUT>#phone#</CFOUTPUT>"></TD></TR>
<TRXTD align="right">
<CFIF isDefined("URL.Key")>
<input type="Hidden" name="Key"

value="<CFOUTPUT>#URL.Keyt</CFOUTPUT>">
</CFIF>
<input type="Hidden" name="Type"

value="<CFOUTPUT>#Type#</CFOUTPUT>">
<input type="submit"

value=" <CFOUTPUT>#Type#</CFOUTPUT> "></TD><TD>
<input type="reset" value="Clear"></TD></TR>
</TABLE>
</FORM>

</BODY>

</HTHL>
<CFELSE>

Листинг П2.19. Код страницы deletesel_addr.cfm

<TITLE>Delete Select Addresses</TITLE>
</HEAD>

<BODY bgcolor="<cfoutput>#Application.myBGColorl</cfoutput>">
<CFIF isDefined("URL.DelAddr")>

<CFQUERY NAME="DeleteAddr" DATASOURCE="#Application.dsn#">
DELETE * FROM Addresses WHERE Key_Addr IN (ttURL.DelAddr#)
</CFQUERY>
</CFIF>

</HTML>
<CFELSE>

Листинг П2.20. Код страницы logout.cfm

<HEAD>

<META HTTP-EQUIV="Refresh" CONTENT="0;URL=login.cfm">
<TITLE>Logout</TITLE>

</HEAD>

<BODY bgcolor="<cfoutput>#Application.myBGColort</cfoutput>">

</BODY>
</HTML>

Код страницы help.cfm не рассматривается, т. к. ее содержание может быть
абсолютно произвольным.